home *** CD-ROM | disk | FTP | other *** search
- <?xml version="1.0" encoding="UTF-8"?>
- <tree_view version="02-Apr-2003">
- <help_section application="scalc" id="08" title="Spreadsheets">
- <node id="0801" title="General Information and User Interface Usage">
- <topic id="66771" src="text/scalc/main0000.xml">Welcome to the %PRODUCTNAME Calc Help</topic>
- <topic id="66762" src="text/scalc/main0503.xml">%PRODUCTNAME Calc Features</topic>
- <topic id="68614" src="text/scalc/guide/keyboard.xml">Shortcut Keys (%PRODUCTNAME Calc Accessibility)</topic>
- <topic id="66941" src="text/scalc/04/01020000.xml">Shortcut Keys for Spreadsheets</topic>
- <topic id="66944" src="text/scalc/05/02140000.xml">Error Codes in %PRODUCTNAME Calc</topic>
- <topic id="66914" src="text/scalc/01/04060112.xml">Add-in for Programming in %PRODUCTNAME Calc</topic>
- <topic id="68232" src="text/scalc/guide/main.xml">Instructions for Using %PRODUCTNAME Calc</topic>
- </node>
- <node id="0802" title="Command and Menu Reference">
- <node id="080201" title="Menus">
- <topic id="66766" src="text/scalc/main0100.xml">Menus</topic>
- <topic id="66755" src="text/scalc/main0101.xml">File</topic>
- <topic id="66767" src="text/scalc/main0102.xml">Edit</topic>
- <topic id="66753" src="text/scalc/main0103.xml">View</topic>
- <topic id="66769" src="text/scalc/main0104.xml">Insert</topic>
- <topic id="66765" src="text/scalc/main0105.xml">Format</topic>
- <topic id="66752" src="text/scalc/main0106.xml">Tools</topic>
- <topic id="66760" src="text/scalc/main0107.xml">Window</topic>
- <topic id="66759" src="text/scalc/main0112.xml">Data</topic>
- </node>
- <node id="080202" title="Toolbars">
- <topic id="66764" src="text/scalc/main0200.xml">Toolbars</topic>
- <topic id="66754" src="text/scalc/main0202.xml">Spreadsheet Object Bar</topic>
- <topic id="66761" src="text/scalc/main0203.xml">Object Bar for a Selected Object</topic>
- <topic id="66758" src="text/scalc/main0205.xml">Object Bar for Text in a Text Object</topic>
- <topic id="66768" src="text/scalc/main0206.xml">Formula Bar</topic>
- <topic id="66763" src="text/scalc/main0208.xml">Status Bar</topic>
- <topic id="66757" src="text/scalc/main0210.xml">Page View Object Bar</topic>
- <topic id="67876" src="text/scalc/main0214.xml">Graphic Object Bar</topic>
- <topic id="66770" src="text/scalc/main0218.xml">Main Toolbar</topic>
- <topic id="65554" src="text/common/main0201.xml">Function Bar</topic>
- <topic id="65577" src="text/common/main0209.xml">Hyperlink Bar</topic>
- <topic id="65557" src="text/common/main0212.xml">Database Bar</topic>
- <topic id="65578" src="text/common/main0213.xml">Form Toolbar</topic>
- <topic id="65564" src="text/common/main0214.xml">SQL Object Bar</topic>
- <topic id="65539" src="text/common/main0226.xml">Object Toolbar when Creating Forms</topic>
- </node>
- </node>
- <node id="0803" title="Functions Types and Operators">
- <topic id="66841" src="text/scalc/01/04060000.xml">AutoPilot: Functions</topic>
- <topic id="66815" src="text/scalc/01/04060100.xml">Categories and Functions</topic>
- <topic id="66856" src="text/scalc/01/04060101.xml">Database Functions</topic>
- <topic id="66874" src="text/scalc/01/04060102.xml">Date + Time Functions</topic>
- <topic id="66877" src="text/scalc/01/04060103.xml">Financial Functions Part One</topic>
- <topic id="68336" src="text/scalc/01/04060119.xml">Financial Functions Part Two</topic>
- <topic id="68335" src="text/scalc/01/04060118.xml">Financial Functions Part Three</topic>
- <topic id="66801" src="text/scalc/01/04060104.xml">Information Functions</topic>
- <topic id="66920" src="text/scalc/01/04060105.xml">Logical Functions</topic>
- <topic id="66824" src="text/scalc/01/04060106.xml">Mathematical Functions</topic>
- <topic id="66878" src="text/scalc/01/04060107.xml">Array Functions</topic>
- <topic id="66820" src="text/scalc/01/04060108.xml">Statistics Functions</topic>
- <topic id="66884" src="text/scalc/01/04060181.xml">Statistical Functions Part One</topic>
- <topic id="66918" src="text/scalc/01/04060182.xml">Statistical Functions Part Two</topic>
- <topic id="66812" src="text/scalc/01/04060183.xml">Statistical Functions Part Three</topic>
- <topic id="66889" src="text/scalc/01/04060184.xml">Statistical Functions Part Four</topic>
- <topic id="66834" src="text/scalc/01/04060185.xml">Statistical Functions Part Five</topic>
- <topic id="66791" src="text/scalc/01/04060109.xml">Spreadsheet Functions</topic>
- <topic id="66819" src="text/scalc/01/04060110.xml">Text Functions</topic>
- <topic id="66872" src="text/scalc/01/04060111.xml">Add-in Functions</topic>
- <topic id="68333" src="text/scalc/01/04060115.xml">Add-in Functions, List of Analysis Functions Part One</topic>
- <topic id="68331" src="text/scalc/01/04060116.xml">Add-in Functions, List of Analysis Functions Part Two</topic>
-
- <topic id="66792" src="text/scalc/01/04060199.xml">Operators in %PRODUCTNAME Calc</topic>
- <topic id="68166" src="text/scalc/guide/userdefined_function.xml">Defining Functions Yourself</topic>
- </node>
- <node id="0804" title="Loading, Saving, Importing, and Exporting">
- <topic id="68398" src="text/scalc/guide/webquery.xml">Inserting External Data in Table (WebQuery)</topic>
- <topic id="68164" src="text/scalc/guide/html_doc.xml">Saving and Opening Sheets in HTML</topic>
- <topic id="68161" src="text/scalc/guide/csv_formula.xml">Importing and Exporting Text Files</topic>
- </node>
- <node id="0805" title="Formatting">
- <topic id="68107" src="text/scalc/guide/text_rotate.xml">Rotating Text</topic>
- <topic id="68089" src="text/scalc/guide/text_wrap.xml">Writing Multi-line Text</topic>
- <topic id="68077" src="text/scalc/guide/text_numbers.xml">Formatting Numbers as Text</topic>
- <topic id="68103" src="text/scalc/guide/super_subscript.xml">Text Superscript / Subscript</topic>
- <topic id="68174" src="text/scalc/guide/row_height.xml">Changing Row Height or Column Width</topic>
- <topic id="68151" src="text/scalc/guide/cellstyle_conditional.xml">Applying Conditional Formatting</topic>
- <topic id="68152" src="text/scalc/guide/cellstyle_minusvalue.xml">Highlighting Negative Numbers</topic>
- <topic id="68149" src="text/scalc/guide/cellstyle_by_formula.xml">Assigning Formats by Formula</topic>
- <topic id="68083" src="text/scalc/guide/integer_leading_zero.xml">Entering a Number with Leading Zeros</topic>
- <topic id="68205" src="text/scalc/guide/format_table.xml">Designing Spreadsheets</topic>
- <topic id="68079" src="text/scalc/guide/format_value.xml">Formatting Numbers With Decimals</topic>
- <topic id="68169" src="text/scalc/guide/value_with_name.xml">Naming Cells</topic>
- <topic id="68281" src="text/scalc/guide/table_rotate.xml">Rotating Tables (Transposing)</topic>
- <topic id="68088" src="text/scalc/guide/rename_table.xml">Renaming Sheets</topic>
- <topic id="68090" src="text/scalc/guide/year2000.xml">19xx/20xx Years</topic>
- <topic id="68432" src="text/scalc/guide/rounding_numbers.xml">Using Rounded Off Numbers</topic>
- <topic id="68076" src="text/scalc/guide/currency_format.xml">Cells in Currency Format</topic>
- <topic id="68067" src="text/scalc/guide/autoformat.xml">Using AutoFormat for Tables</topic>
- <topic id="68087" src="text/scalc/guide/note_insert.xml">Inserting and Editing Notes</topic>
- <topic id="68263" src="text/scalc/guide/design.xml">Selecting Themes for Sheets</topic>
- <topic id="68082" src="text/scalc/guide/fraction_enter.xml">Entering Fractions</topic>
- </node>
- <node id="0806" title="Filtering and Sorting">
- <topic id="68139" src="text/scalc/guide/filters.xml">Applying Filters</topic>
- <topic id="68142" src="text/scalc/guide/specialfilter.xml">Filter: Applying Advanced Filters</topic>
- <topic id="68141" src="text/scalc/guide/standardfilter.xml">Filter: Applying Standard Filters</topic>
- <topic id="68140" src="text/scalc/guide/autofilter.xml">Applying AutoFilter</topic>
- <topic id="68072" src="text/scalc/guide/sorted_list.xml">Applying Sort Lists</topic>
- </node>
- <node id="0807" title="Printing">
- <topic id="68168" src="text/scalc/guide/print_title_row.xml">Printing Rows or Columns on Every Page</topic>
- <topic id="68163" src="text/scalc/guide/print_landscape.xml">Printing Sheets in Landscape Format</topic>
- <topic id="68252" src="text/scalc/guide/print_details.xml">Printing Sheet Details</topic>
- <topic id="68110" src="text/scalc/guide/print_exact.xml">Defining Number of Pages for Printing</topic>
- </node>
- <node id="0808" title="Data Ranges">
- <topic id="68201" src="text/scalc/guide/database_define.xml">Defining Database Ranges</topic>
- <topic id="68203" src="text/scalc/guide/database_filter.xml">Filtering Database Ranges</topic>
- <topic id="68204" src="text/scalc/guide/database_group.xml">Grouping Database Ranges and Calculating Subtotals</topic>
- <topic id="68202" src="text/scalc/guide/database_sort.xml">Sorting Database Ranges</topic>
- </node>
- <node id="0809" title="Data Pilot">
- <topic id="68153" src="text/scalc/guide/datapilot.xml">DataPilot</topic>
- <topic id="68154" src="text/scalc/guide/datapilot_createtable.xml">Creating DataPilot Tables</topic>
- <topic id="68159" src="text/scalc/guide/datapilot_deletetable.xml">Deleting DataPilot Tables</topic>
- <topic id="68155" src="text/scalc/guide/datapilot_edittable.xml">Editing DataPilot Tables</topic>
- <topic id="68156" src="text/scalc/guide/datapilot_filtertable.xml">Filtering DataPilot Tables</topic>
- <topic id="68158" src="text/scalc/guide/datapilot_tipps.xml">Selecting DataPilot Output Ranges</topic>
- <topic id="68157" src="text/scalc/guide/datapilot_updatetable.xml">Updating DataPilot Tables</topic>
- </node>
- <node id="0810" title="Scenarios">
- <topic id="68475" src="text/scalc/guide/scenario.xml">Using Scenarios</topic>
- </node>
- <node id="0811" title="References">
- <topic id="68064" src="text/scalc/guide/relativ_absolut_ref.xml">Addresses and References, Absolute and Relative</topic>
- <topic id="68075" src="text/scalc/guide/cellreferences.xml">Referencing a Cell in Another Document</topic>
- <topic id="68074" src="text/scalc/guide/cellreferences_url.xml">References to Other Sheets and Referencing URLs</topic>
- <topic id="68145" src="text/scalc/guide/cellreference_dragdrop.xml">Referencing Cells by Drag-and-Drop</topic>
- <topic id="68063" src="text/scalc/guide/address_auto.xml">Recognizing Names as Addressing</topic>
- <topic id="68065" src="text/scalc/guide/address_byname.xml">Addressing by Name</topic>
- </node>
- <node id="0812" title="Viewing, Selecting, Copying">
- <topic id="68292" src="text/scalc/guide/table_view.xml">Changing Table Views</topic>
- <topic id="68167" src="text/scalc/guide/formula_value.xml">Displaying Formulas or Values</topic>
- <topic id="68111" src="text/scalc/guide/line_fix.xml">Freezing Rows or Columns as Headers</topic>
- <topic id="68084" src="text/scalc/guide/multi_tables.xml">Navigating Through Sheets Tabs</topic>
- <topic id="68086" src="text/scalc/guide/edit_multitables.xml">Copying to Multiple Sheets</topic>
- <topic id="68551" src="text/scalc/guide/cellcopy.xml">Only Copy Visible Cells</topic>
- <topic id="68170" src="text/scalc/guide/mark_cells.xml">Selecting Multiple Cells</topic>
- </node>
- <node id="0813" title="Formulas and Calculations">
- <topic id="68081" src="text/scalc/guide/formulas.xml">Calculating With Formulas</topic>
- <topic id="68080" src="text/scalc/guide/formula_copy.xml">Copying Formulas</topic>
- <topic id="68298" src="text/scalc/guide/formula_enter.xml">Entering Formulas in the Formula Bar</topic>
- <topic id="68167" src="text/scalc/guide/formula_value.xml">Displaying Formulas or Values</topic>
- <topic id="68073" src="text/scalc/guide/calculate.xml">Calculating in Spreadsheets</topic>
- <topic id="68068" src="text/scalc/guide/calc_date.xml">Calculating With Dates and Times</topic>
- <topic id="68070" src="text/scalc/guide/calc_series.xml">Automatically Calculating Series</topic>
- <topic id="68069" src="text/scalc/guide/calc_timevalues.xml">Calculating Time Differences</topic>
- <topic id="68160" src="text/scalc/guide/matrixformula.xml">Entering Matrix Formulas</topic>
- </node>
- <node id="0814" title="Protection">
- <topic id="68146" src="text/scalc/guide/cell_protect.xml">Protecting Cells from Changes</topic>
- <topic id="68147" src="text/scalc/guide/cell_unprotect.xml">Unprotecting Cells</topic>
- </node>
- <node id="0815" title="Miscellaneous">
- <topic id="68071" src="text/scalc/guide/autofill.xml">Auto Filling Cells</topic>
- <topic id="68413" src="text/scalc/guide/auto_off.xml">Deactivating Automatic Changes</topic>
- <topic id="68148" src="text/scalc/guide/consolidate.xml">Consolidating Data</topic>
- <topic id="68143" src="text/scalc/guide/goalseek.xml">Applying Goal Seek</topic>
- <topic id="68399" src="text/scalc/guide/multioperation.xml">Applying Multiple Operations</topic>
- <topic id="68085" src="text/scalc/guide/multitables.xml">Applying Multiple Sheets</topic>
- <topic id="68144" src="text/scalc/guide/validity.xml">Validity of Cell Contents</topic>
- </node>
- </help_section>
- </tree_view>
-